{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 获取推广员姓名对应数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "namePath = './datas/name_clean.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "nameData = pd.read_excel(namePath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>微信名称</th>\n",
       "      <th>手机号码</th>\n",
       "      <th>邀请方</th>\n",
       "      <th>累计成交笔数</th>\n",
       "      <th>累计成交金额</th>\n",
       "      <th>推广员昵称</th>\n",
       "      <th>真实姓名</th>\n",
       "      <th>大区</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>张君朔</td>\n",
       "      <td>13139051119</td>\n",
       "      <td>魏伟</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>晟道文化～周航</td>\n",
       "      <td>13752990918</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>艾米妮亚服务顾问黄佳</td>\n",
       "      <td>17623367095</td>\n",
       "      <td>黄雪艳</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>王春盛 19905101314</td>\n",
       "      <td>13851085877</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>晟道文化-刘琼</td>\n",
       "      <td>13970942232</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>6</td>\n",
       "      <td>198.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>晟道文化-宋阳</td>\n",
       "      <td>13601921997</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>晟道文化-丹丹</td>\n",
       "      <td>13637991341</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>宋苗</td>\n",
       "      <td>13883612737</td>\n",
       "      <td>-</td>\n",
       "      <td>27</td>\n",
       "      <td>992.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>-</td>\n",
       "      <td>15</td>\n",
       "      <td>399.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>晟道文化-尚炎彬</td>\n",
       "      <td>15037979381</td>\n",
       "      <td>-</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>257 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 微信名称         手机号码       邀请方  累计成交笔数  累计成交金额 推广员昵称 真实姓名   大区\n",
       "0                 张君朔  13139051119        魏伟       0     0.0   NaN  NaN  NaN\n",
       "1             晟道文化～周航  13752990918   晟道集团睢小光       0     0.0   NaN  NaN  NaN\n",
       "2          艾米妮亚服务顾问黄佳  17623367095       黄雪艳       0     0.0   NaN  NaN  NaN\n",
       "3     王春盛 19905101314  13851085877   晟道集团睢小光       0     0.0   NaN  NaN  NaN\n",
       "4             晟道文化-刘琼  13970942232   晟道集团睢小光       6   198.4   NaN  NaN  NaN\n",
       "..                ...          ...       ...     ...     ...   ...  ...  ...\n",
       "252           晟道文化-宋阳  13601921997         -       0     0.0   NaN  NaN  NaN\n",
       "253           晟道文化-丹丹  13637991341         -       0     0.0   NaN  NaN  NaN\n",
       "254                宋苗  13883612737         -      27   992.7   NaN  NaN  NaN\n",
       "255               海茉灿  13983935867         -      15   399.8   NaN  NaN  NaN\n",
       "256          晟道文化-尚炎彬  15037979381         -       3     3.0   NaN  NaN  NaN\n",
       "\n",
       "[257 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nameData"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 获取订单数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderPath = './datas/订单和推广员/202004301448-订单导出.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderData = pd.read_excel(orderPath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>支付订单号</th>\n",
       "      <th>支付流水号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>卖家</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>支付类型</th>\n",
       "      <th>冻结</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>商品单价(单位为元)</th>\n",
       "      <th>商品数量</th>\n",
       "      <th>商品名称</th>\n",
       "      <th>卖家备注</th>\n",
       "      <th>团编号</th>\n",
       "      <th>订单类型</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>200430144659000002</td>\n",
       "      <td>012004301446530000009282</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 14:46:51</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>200430144558000016</td>\n",
       "      <td>012004301445520000009264</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 14:45:49</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>200430144533000225</td>\n",
       "      <td>012004301445290000009259</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 14:45:28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>200430144506000061</td>\n",
       "      <td>012004301445020000009247</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 14:45:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>4200000535202004306168821536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>weapp</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 14:44:02</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>200430102320000068</td>\n",
       "      <td>012004301023150000005075</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 10:23:14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>200430101101000087</td>\n",
       "      <td>012004301010550000004881</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 10:10:53</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>200430092045000385</td>\n",
       "      <td>012004300920380000004212</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 09:20:37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>200430090852000025</td>\n",
       "      <td>012004300908490000004040</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-30 09:08:48</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>200429190724000312</td>\n",
       "      <td>012004291907200000014727</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>2020-04-29 19:07:18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>普通订单</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                         支付订单号  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y            200430144659000002   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC            200430144558000016   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD            200430144533000225   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB            200430144506000061   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz  4200000535202004306168821536   \n",
       "..                             ...                           ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY            200430102320000068   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx            200430101101000087   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx            200430092045000385   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa            200430090852000025   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ            200429190724000312   \n",
       "\n",
       "                       支付流水号                    买家 买家真实姓名           卖家  \\\n",
       "0   012004301446530000009282                    远照    王远照  19112655669   \n",
       "1   012004301445520000009264  李义--明珠大酒店18837776662    NaN  19112655669   \n",
       "2   012004301445290000009259      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟  19112655669   \n",
       "3   012004301445020000009247                    渝夏     黄雨  19112655669   \n",
       "4                        NaN                明天会更好!    NaN  19112655669   \n",
       "..                       ...                   ...    ...          ...   \n",
       "80  012004301023150000005075               齐乐^O^蓉蓉    NaN  19112655669   \n",
       "81  012004301010550000004881               遇见·美学策划    NaN  19112655669   \n",
       "82  012004300920380000004212         特色猪棒骨，各种火锅，炒菜    NaN  19112655669   \n",
       "83  012004300908490000004040              爱相随婚庆*庆典    NaN  19112655669   \n",
       "84  012004291907200000014727          爱情果缘婚纱婚庆????    NaN  19112655669   \n",
       "\n",
       "    合计费用(单位为元) 订单状态    支付类型  冻结                 交易时间  商品单价(单位为元)  商品数量  \\\n",
       "0            1  已完成  wechat  No  2020-04-30 14:46:51           1     1   \n",
       "1            1  已完成  wechat  No  2020-04-30 14:45:49           1     1   \n",
       "2            1  已完成  wechat  No  2020-04-30 14:45:28           1     1   \n",
       "3            1  已完成  wechat  No  2020-04-30 14:45:00           1     1   \n",
       "4            1  已完成   weapp  No  2020-04-30 14:44:02           1     1   \n",
       "..         ...  ...     ...  ..                  ...         ...   ...   \n",
       "80           1  已完成  wechat  No  2020-04-30 10:23:14           1     1   \n",
       "81           1  已完成  wechat  No  2020-04-30 10:10:53           1     1   \n",
       "82           1  已完成  wechat  No  2020-04-30 09:20:37           1     1   \n",
       "83           1  已完成  wechat  No  2020-04-30 09:08:48           1     1   \n",
       "84           1  已完成  wechat  No  2020-04-29 19:07:18           1     1   \n",
       "\n",
       "          商品名称  卖家备注  团编号  订单类型  \n",
       "0   【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "1   【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "2   【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "3   【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "4   【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "..         ...   ...  ...   ...  \n",
       "80  【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "81  【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "82  【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "83  【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "84  【万家灯火】爆破行动   NaN  NaN  普通订单  \n",
       "\n",
       "[85 rows x 17 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orderData"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 获取推广订单数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "tuiOrderPath = './datas/订单和推广员/2020-04-30推广纪录.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "tuiOrderData = pd.read_excel(tuiOrderPath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>完成时间</th>\n",
       "      <th>订单号</th>\n",
       "      <th>商品名称</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>推广员昵称</th>\n",
       "      <th>推广员手机号</th>\n",
       "      <th>推广比例</th>\n",
       "      <th>推广佣金</th>\n",
       "      <th>邀请方昵称</th>\n",
       "      <th>邀请方手机号</th>\n",
       "      <th>邀请比例</th>\n",
       "      <th>邀请佣金</th>\n",
       "      <th>状态</th>\n",
       "      <th>结算模式</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2020-04-30 14:52:18</td>\n",
       "      <td>2020-04-30 14:52:35</td>\n",
       "      <td>xnqdTSuXPdqKsCvgM3T4ucYj5Xv1jG</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>1.0</td>\n",
       "      <td>晟道文化～曾杰</td>\n",
       "      <td>18184088118</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道文化–宋苗</td>\n",
       "      <td>13883612737</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2020-04-30 14:50:17</td>\n",
       "      <td>2020-04-30 14:52:38</td>\n",
       "      <td>smx9Vsf8YhPNJ89QTsTn7iaacryh7L</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>1.0</td>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2020-04-30 14:50:05</td>\n",
       "      <td>2020-04-30 14:50:24</td>\n",
       "      <td>djfTDFPmpUFrofpASoh9aLTWO15St8</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>1.0</td>\n",
       "      <td>晟道～怀茂丹</td>\n",
       "      <td>15923189094</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2020-04-30 14:46:51</td>\n",
       "      <td>2020-04-30 14:47:08</td>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>1.0</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>13982910556</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>18610710617</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2020-04-30 14:46:38</td>\n",
       "      <td>2020-04-30 14:48:43</td>\n",
       "      <td>mHhanMd9TtBCZdmFy5iGDei8t0QzfJ</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>1.0</td>\n",
       "      <td>黄雪艳</td>\n",
       "      <td>13271805077</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2634</th>\n",
       "      <td>2635</td>\n",
       "      <td>2020-03-05 22:53:15</td>\n",
       "      <td>2020-03-05 22:53:33</td>\n",
       "      <td>sUgFNqKnd6fChQfsVZhJejC3R70Zos</td>\n",
       "      <td>5G时代—短视频拍摄技法</td>\n",
       "      <td>1.0</td>\n",
       "      <td>晟道文化-尚炎彬</td>\n",
       "      <td>15037979381</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2635</th>\n",
       "      <td>2636</td>\n",
       "      <td>2020-03-05 22:34:10</td>\n",
       "      <td>2020-03-05 22:35:38</td>\n",
       "      <td>79rUhLWcWGCd4GdNnvwAU2gXZO0Z69</td>\n",
       "      <td>5G时代—短视频拍摄技法</td>\n",
       "      <td>1.0</td>\n",
       "      <td>晟道文化-尚炎彬</td>\n",
       "      <td>15037979381</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2636</th>\n",
       "      <td>2637</td>\n",
       "      <td>2020-03-05 22:31:27</td>\n",
       "      <td>2020-03-05 22:31:45</td>\n",
       "      <td>y2okjJyxEJsyoQh4KHMG4WFYbrmSFL</td>\n",
       "      <td>5G时代—短视频拍摄技法</td>\n",
       "      <td>1.0</td>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2637</th>\n",
       "      <td>2638</td>\n",
       "      <td>2020-03-05 22:31:11</td>\n",
       "      <td>2020-03-05 22:31:28</td>\n",
       "      <td>X9PnCiMpWSUpAyYDZZbaUK9tzw28t4</td>\n",
       "      <td>5G时代—短视频拍摄技法</td>\n",
       "      <td>1.0</td>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2638</th>\n",
       "      <td>2639</td>\n",
       "      <td>2020-03-05 22:31:09</td>\n",
       "      <td>2020-03-05 22:31:34</td>\n",
       "      <td>LvBA4rKJMyeTUgAR7wpo5At56wttAR</td>\n",
       "      <td>5G时代—短视频拍摄技法</td>\n",
       "      <td>1.0</td>\n",
       "      <td>海茉灿</td>\n",
       "      <td>13983935867</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2639 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        序号                 交易时间                 完成时间  \\\n",
       "0        1  2020-04-30 14:52:18  2020-04-30 14:52:35   \n",
       "1        2  2020-04-30 14:50:17  2020-04-30 14:52:38   \n",
       "2        3  2020-04-30 14:50:05  2020-04-30 14:50:24   \n",
       "3        4  2020-04-30 14:46:51  2020-04-30 14:47:08   \n",
       "4        5  2020-04-30 14:46:38  2020-04-30 14:48:43   \n",
       "...    ...                  ...                  ...   \n",
       "2634  2635  2020-03-05 22:53:15  2020-03-05 22:53:33   \n",
       "2635  2636  2020-03-05 22:34:10  2020-03-05 22:35:38   \n",
       "2636  2637  2020-03-05 22:31:27  2020-03-05 22:31:45   \n",
       "2637  2638  2020-03-05 22:31:11  2020-03-05 22:31:28   \n",
       "2638  2639  2020-03-05 22:31:09  2020-03-05 22:31:34   \n",
       "\n",
       "                                 订单号          商品名称  成交金额        推广员昵称  \\\n",
       "0     xnqdTSuXPdqKsCvgM3T4ucYj5Xv1jG    【万家灯火】爆破行动   1.0      晟道文化～曾杰   \n",
       "1     smx9Vsf8YhPNJ89QTsTn7iaacryh7L    【万家灯火】爆破行动   1.0          海茉灿   \n",
       "2     djfTDFPmpUFrofpASoh9aLTWO15St8    【万家灯火】爆破行动   1.0       晟道～怀茂丹   \n",
       "3     wkfC9TWJVcbcWNUSow2tu6Giwarv7y    【万家灯火】爆破行动   1.0   成都千禧喜洋洋杨选华   \n",
       "4     mHhanMd9TtBCZdmFy5iGDei8t0QzfJ    【万家灯火】爆破行动   1.0          黄雪艳   \n",
       "...                              ...           ...   ...          ...   \n",
       "2634  sUgFNqKnd6fChQfsVZhJejC3R70Zos  5G时代—短视频拍摄技法   1.0     晟道文化-尚炎彬   \n",
       "2635  79rUhLWcWGCd4GdNnvwAU2gXZO0Z69  5G时代—短视频拍摄技法   1.0     晟道文化-尚炎彬   \n",
       "2636  y2okjJyxEJsyoQh4KHMG4WFYbrmSFL  5G时代—短视频拍摄技法   1.0          海茉灿   \n",
       "2637  X9PnCiMpWSUpAyYDZZbaUK9tzw28t4  5G时代—短视频拍摄技法   1.0          海茉灿   \n",
       "2638  LvBA4rKJMyeTUgAR7wpo5At56wttAR  5G时代—短视频拍摄技法   1.0          海茉灿   \n",
       "\n",
       "           推广员手机号 推广比例  推广佣金     邀请方昵称       邀请方手机号 邀请比例  邀请佣金   状态  结算模式  \n",
       "0     18184088118  15%  0.15   晟道文化–宋苗  13883612737   6%  0.06  已支付  自动结算  \n",
       "1     13983935867  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "2     15923189094  15%  0.15       海茉灿  13983935867   6%  0.06  已支付  自动结算  \n",
       "3     13982910556  15%  0.15   晟道文化-李庆  18610710617   6%  0.06  已支付  自动结算  \n",
       "4     13271805077  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "...           ...  ...   ...       ...          ...  ...   ...  ...   ...  \n",
       "2634  15037979381  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "2635  15037979381  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "2636  13983935867  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "2637  13983935867  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "2638  13983935867  15%  0.15        --           --   --    --  已支付  自动结算  \n",
       "\n",
       "[2639 rows x 16 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tuiOrderData"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 合并订单和推广订单数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "orer_tuiguangOrder_data = pd.merge(orderData,tuiOrderData,left_on='订单编号',right_on='订单号',how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>支付订单号</th>\n",
       "      <th>支付流水号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>卖家</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>支付类型</th>\n",
       "      <th>冻结</th>\n",
       "      <th>...</th>\n",
       "      <th>推广员昵称</th>\n",
       "      <th>推广员手机号</th>\n",
       "      <th>推广比例</th>\n",
       "      <th>推广佣金</th>\n",
       "      <th>邀请方昵称</th>\n",
       "      <th>邀请方手机号</th>\n",
       "      <th>邀请比例</th>\n",
       "      <th>邀请佣金</th>\n",
       "      <th>状态</th>\n",
       "      <th>结算模式</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>200430144659000002</td>\n",
       "      <td>012004301446530000009282</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>1.398291e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>18610710617</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>200430144558000016</td>\n",
       "      <td>012004301445520000009264</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>200430144533000225</td>\n",
       "      <td>012004301445290000009259</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>200430144506000061</td>\n",
       "      <td>012004301445020000009247</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>1.861071e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>4200000535202004306168821536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>weapp</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>200430102320000068</td>\n",
       "      <td>012004301023150000005075</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>200430101101000087</td>\n",
       "      <td>012004301010550000004881</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>200430092045000385</td>\n",
       "      <td>012004300920380000004212</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>200430090852000025</td>\n",
       "      <td>012004300908490000004040</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>200429190724000312</td>\n",
       "      <td>012004291907200000014727</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                         支付订单号  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y            200430144659000002   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC            200430144558000016   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD            200430144533000225   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB            200430144506000061   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz  4200000535202004306168821536   \n",
       "..                             ...                           ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY            200430102320000068   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx            200430101101000087   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx            200430092045000385   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa            200430090852000025   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ            200429190724000312   \n",
       "\n",
       "                       支付流水号                    买家 买家真实姓名           卖家  \\\n",
       "0   012004301446530000009282                    远照    王远照  19112655669   \n",
       "1   012004301445520000009264  李义--明珠大酒店18837776662    NaN  19112655669   \n",
       "2   012004301445290000009259      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟  19112655669   \n",
       "3   012004301445020000009247                    渝夏     黄雨  19112655669   \n",
       "4                        NaN                明天会更好!    NaN  19112655669   \n",
       "..                       ...                   ...    ...          ...   \n",
       "80  012004301023150000005075               齐乐^O^蓉蓉    NaN  19112655669   \n",
       "81  012004301010550000004881               遇见·美学策划    NaN  19112655669   \n",
       "82  012004300920380000004212         特色猪棒骨，各种火锅，炒菜    NaN  19112655669   \n",
       "83  012004300908490000004040              爱相随婚庆*庆典    NaN  19112655669   \n",
       "84  012004291907200000014727          爱情果缘婚纱婚庆????    NaN  19112655669   \n",
       "\n",
       "    合计费用(单位为元) 订单状态    支付类型  冻结  ...        推广员昵称        推广员手机号  推广比例  推广佣金  \\\n",
       "0            1  已完成  wechat  No  ...   成都千禧喜洋洋杨选华  1.398291e+10   15%  0.15   \n",
       "1            1  已完成  wechat  No  ...          NaN           NaN   NaN   NaN   \n",
       "2            1  已完成  wechat  No  ...          NaN           NaN   NaN   NaN   \n",
       "3            1  已完成  wechat  No  ...      晟道文化-李庆  1.861071e+10   15%  0.15   \n",
       "4            1  已完成   weapp  No  ...          NaN           NaN   NaN   NaN   \n",
       "..         ...  ...     ...  ..  ...          ...           ...   ...   ...   \n",
       "80           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "81           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "82           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "83           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "84           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "\n",
       "       邀请方昵称       邀请方手机号 邀请比例  邀请佣金   状态  结算模式  \n",
       "0    晟道文化-李庆  18610710617   6%  0.06  已支付  自动结算  \n",
       "1        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "2        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "3    晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "4        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "..       ...          ...  ...   ...  ...   ...  \n",
       "80   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "81   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "82   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "83   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "84   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "\n",
       "[85 rows x 33 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orer_tuiguangOrder_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "complete_order_data = orer_tuiguangOrder_data.loc[orer_tuiguangOrder_data['订单状态']=='已完成',:].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>支付订单号</th>\n",
       "      <th>支付流水号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>卖家</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>支付类型</th>\n",
       "      <th>冻结</th>\n",
       "      <th>...</th>\n",
       "      <th>推广员昵称</th>\n",
       "      <th>推广员手机号</th>\n",
       "      <th>推广比例</th>\n",
       "      <th>推广佣金</th>\n",
       "      <th>邀请方昵称</th>\n",
       "      <th>邀请方手机号</th>\n",
       "      <th>邀请比例</th>\n",
       "      <th>邀请佣金</th>\n",
       "      <th>状态</th>\n",
       "      <th>结算模式</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>200430144659000002</td>\n",
       "      <td>012004301446530000009282</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>1.398291e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>18610710617</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>200430144558000016</td>\n",
       "      <td>012004301445520000009264</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>200430144533000225</td>\n",
       "      <td>012004301445290000009259</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>200430144506000061</td>\n",
       "      <td>012004301445020000009247</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>1.861071e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>4200000535202004306168821536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>weapp</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>200430102320000068</td>\n",
       "      <td>012004301023150000005075</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>200430101101000087</td>\n",
       "      <td>012004301010550000004881</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>200430092045000385</td>\n",
       "      <td>012004300920380000004212</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>200430090852000025</td>\n",
       "      <td>012004300908490000004040</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>200429190724000312</td>\n",
       "      <td>012004291907200000014727</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19112655669</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>wechat</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                         支付订单号  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y            200430144659000002   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC            200430144558000016   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD            200430144533000225   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB            200430144506000061   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz  4200000535202004306168821536   \n",
       "..                             ...                           ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY            200430102320000068   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx            200430101101000087   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx            200430092045000385   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa            200430090852000025   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ            200429190724000312   \n",
       "\n",
       "                       支付流水号                    买家 买家真实姓名           卖家  \\\n",
       "0   012004301446530000009282                    远照    王远照  19112655669   \n",
       "1   012004301445520000009264  李义--明珠大酒店18837776662    NaN  19112655669   \n",
       "2   012004301445290000009259      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟  19112655669   \n",
       "3   012004301445020000009247                    渝夏     黄雨  19112655669   \n",
       "4                        NaN                明天会更好!    NaN  19112655669   \n",
       "..                       ...                   ...    ...          ...   \n",
       "80  012004301023150000005075               齐乐^O^蓉蓉    NaN  19112655669   \n",
       "81  012004301010550000004881               遇见·美学策划    NaN  19112655669   \n",
       "82  012004300920380000004212         特色猪棒骨，各种火锅，炒菜    NaN  19112655669   \n",
       "83  012004300908490000004040              爱相随婚庆*庆典    NaN  19112655669   \n",
       "84  012004291907200000014727          爱情果缘婚纱婚庆????    NaN  19112655669   \n",
       "\n",
       "    合计费用(单位为元) 订单状态    支付类型  冻结  ...        推广员昵称        推广员手机号  推广比例  推广佣金  \\\n",
       "0            1  已完成  wechat  No  ...   成都千禧喜洋洋杨选华  1.398291e+10   15%  0.15   \n",
       "1            1  已完成  wechat  No  ...          NaN           NaN   NaN   NaN   \n",
       "2            1  已完成  wechat  No  ...          NaN           NaN   NaN   NaN   \n",
       "3            1  已完成  wechat  No  ...      晟道文化-李庆  1.861071e+10   15%  0.15   \n",
       "4            1  已完成   weapp  No  ...          NaN           NaN   NaN   NaN   \n",
       "..         ...  ...     ...  ..  ...          ...           ...   ...   ...   \n",
       "80           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "81           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "82           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "83           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "84           1  已完成  wechat  No  ...      晟道集团～王平  1.343608e+10   15%  0.15   \n",
       "\n",
       "       邀请方昵称       邀请方手机号 邀请比例  邀请佣金   状态  结算模式  \n",
       "0    晟道文化-李庆  18610710617   6%  0.06  已支付  自动结算  \n",
       "1        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "2        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "3    晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "4        NaN          NaN  NaN   NaN  NaN   NaN  \n",
       "..       ...          ...  ...   ...  ...   ...  \n",
       "80   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "81   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "82   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "83   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "84   晟道集团睢小光  18725629069   6%  0.06  已支付  自动结算  \n",
       "\n",
       "[85 rows x 33 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "complete_order_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 删除不必要的列\n",
    "complete_order_data.drop(['支付订单号','支付流水号','卖家','支付类型','冻结','交易时间_x','卖家备注','团编号'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>商品单价(单位为元)</th>\n",
       "      <th>商品数量</th>\n",
       "      <th>商品名称_x</th>\n",
       "      <th>订单类型</th>\n",
       "      <th>序号</th>\n",
       "      <th>...</th>\n",
       "      <th>推广员昵称</th>\n",
       "      <th>推广员手机号</th>\n",
       "      <th>推广比例</th>\n",
       "      <th>推广佣金</th>\n",
       "      <th>邀请方昵称</th>\n",
       "      <th>邀请方手机号</th>\n",
       "      <th>邀请比例</th>\n",
       "      <th>邀请佣金</th>\n",
       "      <th>状态</th>\n",
       "      <th>结算模式</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>1.398291e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>18610710617</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>1.861071e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>72.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>73.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>74.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>18725629069</td>\n",
       "      <td>6%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                    买家 买家真实姓名  合计费用(单位为元)  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y                    远照    王远照           1   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC  李义--明珠大酒店18837776662    NaN           1   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟           1   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB                    渝夏     黄雨           1   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz                明天会更好!    NaN           1   \n",
       "..                             ...                   ...    ...         ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY               齐乐^O^蓉蓉    NaN           1   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx               遇见·美学策划    NaN           1   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx         特色猪棒骨，各种火锅，炒菜    NaN           1   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa              爱相随婚庆*庆典    NaN           1   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ          爱情果缘婚纱婚庆????    NaN           1   \n",
       "\n",
       "   订单状态  商品单价(单位为元)  商品数量      商品名称_x  订单类型    序号  ...        推广员昵称  \\\n",
       "0   已完成           1     1  【万家灯火】爆破行动  普通订单   4.0  ...   成都千禧喜洋洋杨选华   \n",
       "1   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...          NaN   \n",
       "2   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...          NaN   \n",
       "3   已完成           1     1  【万家灯火】爆破行动  普通订单   6.0  ...      晟道文化-李庆   \n",
       "4   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...          NaN   \n",
       "..  ...         ...   ...         ...   ...   ...  ...          ...   \n",
       "80  已完成           1     1  【万家灯火】爆破行动  普通订单  72.0  ...      晟道集团～王平   \n",
       "81  已完成           1     1  【万家灯火】爆破行动  普通订单  73.0  ...      晟道集团～王平   \n",
       "82  已完成           1     1  【万家灯火】爆破行动  普通订单  74.0  ...      晟道集团～王平   \n",
       "83  已完成           1     1  【万家灯火】爆破行动  普通订单  75.0  ...      晟道集团～王平   \n",
       "84  已完成           1     1  【万家灯火】爆破行动  普通订单  77.0  ...      晟道集团～王平   \n",
       "\n",
       "          推广员手机号 推广比例  推广佣金     邀请方昵称       邀请方手机号  邀请比例  邀请佣金   状态  结算模式  \n",
       "0   1.398291e+10  15%  0.15   晟道文化-李庆  18610710617    6%  0.06  已支付  自动结算  \n",
       "1            NaN  NaN   NaN       NaN          NaN   NaN   NaN  NaN   NaN  \n",
       "2            NaN  NaN   NaN       NaN          NaN   NaN   NaN  NaN   NaN  \n",
       "3   1.861071e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "4            NaN  NaN   NaN       NaN          NaN   NaN   NaN  NaN   NaN  \n",
       "..           ...  ...   ...       ...          ...   ...   ...  ...   ...  \n",
       "80  1.343608e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "81  1.343608e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "82  1.343608e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "83  1.343608e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "84  1.343608e+10  15%  0.15   晟道集团睢小光  18725629069    6%  0.06  已支付  自动结算  \n",
       "\n",
       "[85 rows x 25 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "complete_order_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 数据导出\n",
    "# complete_order_data.to_excel('./datas/order_clean.xlsx',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "order_name_data = pd.merge(complete_order_data,nameData,left_on='推广员昵称',right_on='微信名称',how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>商品单价(单位为元)</th>\n",
       "      <th>商品数量</th>\n",
       "      <th>商品名称_x</th>\n",
       "      <th>订单类型</th>\n",
       "      <th>序号</th>\n",
       "      <th>...</th>\n",
       "      <th>状态</th>\n",
       "      <th>结算模式</th>\n",
       "      <th>微信名称</th>\n",
       "      <th>手机号码</th>\n",
       "      <th>邀请方</th>\n",
       "      <th>累计成交笔数</th>\n",
       "      <th>累计成交金额</th>\n",
       "      <th>推广员昵称_y</th>\n",
       "      <th>真实姓名</th>\n",
       "      <th>大区</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>1.398291e+10</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>30.0</td>\n",
       "      <td>498.4</td>\n",
       "      <td>成都千禧喜洋洋杨选华</td>\n",
       "      <td>杨选华</td>\n",
       "      <td>一区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>1.861071e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>508.0</td>\n",
       "      <td>7433.4</td>\n",
       "      <td>晟道文化-李庆</td>\n",
       "      <td>李庆</td>\n",
       "      <td>总部</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>72.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>73.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>74.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>已支付</td>\n",
       "      <td>自动结算</td>\n",
       "      <td>晟道集团～王平</td>\n",
       "      <td>1.343608e+10</td>\n",
       "      <td>晟道集团睢小光</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                    买家 买家真实姓名  合计费用(单位为元)  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y                    远照    王远照           1   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC  李义--明珠大酒店18837776662    NaN           1   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟           1   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB                    渝夏     黄雨           1   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz                明天会更好!    NaN           1   \n",
       "..                             ...                   ...    ...         ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY               齐乐^O^蓉蓉    NaN           1   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx               遇见·美学策划    NaN           1   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx         特色猪棒骨，各种火锅，炒菜    NaN           1   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa              爱相随婚庆*庆典    NaN           1   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ          爱情果缘婚纱婚庆????    NaN           1   \n",
       "\n",
       "   订单状态  商品单价(单位为元)  商品数量      商品名称_x  订单类型    序号  ...   状态  结算模式  \\\n",
       "0   已完成           1     1  【万家灯火】爆破行动  普通订单   4.0  ...  已支付  自动结算   \n",
       "1   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN   NaN   \n",
       "2   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN   NaN   \n",
       "3   已完成           1     1  【万家灯火】爆破行动  普通订单   6.0  ...  已支付  自动结算   \n",
       "4   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN   NaN   \n",
       "..  ...         ...   ...         ...   ...   ...  ...  ...   ...   \n",
       "80  已完成           1     1  【万家灯火】爆破行动  普通订单  72.0  ...  已支付  自动结算   \n",
       "81  已完成           1     1  【万家灯火】爆破行动  普通订单  73.0  ...  已支付  自动结算   \n",
       "82  已完成           1     1  【万家灯火】爆破行动  普通订单  74.0  ...  已支付  自动结算   \n",
       "83  已完成           1     1  【万家灯火】爆破行动  普通订单  75.0  ...  已支付  自动结算   \n",
       "84  已完成           1     1  【万家灯火】爆破行动  普通订单  77.0  ...  已支付  自动结算   \n",
       "\n",
       "           微信名称          手机号码       邀请方 累计成交笔数  累计成交金额      推广员昵称_y  真实姓名   大区  \n",
       "0    成都千禧喜洋洋杨选华  1.398291e+10   晟道文化-李庆   30.0   498.4   成都千禧喜洋洋杨选华   杨选华   一区  \n",
       "1           NaN           NaN       NaN    NaN     NaN          NaN   NaN  NaN  \n",
       "2           NaN           NaN       NaN    NaN     NaN          NaN   NaN  NaN  \n",
       "3       晟道文化-李庆  1.861071e+10   晟道集团睢小光  508.0  7433.4      晟道文化-李庆    李庆   总部  \n",
       "4           NaN           NaN       NaN    NaN     NaN          NaN   NaN  NaN  \n",
       "..          ...           ...       ...    ...     ...          ...   ...  ...  \n",
       "80      晟道集团～王平  1.343608e+10   晟道集团睢小光    9.0     7.2          NaN   NaN  NaN  \n",
       "81      晟道集团～王平  1.343608e+10   晟道集团睢小光    9.0     7.2          NaN   NaN  NaN  \n",
       "82      晟道集团～王平  1.343608e+10   晟道集团睢小光    9.0     7.2          NaN   NaN  NaN  \n",
       "83      晟道集团～王平  1.343608e+10   晟道集团睢小光    9.0     7.2          NaN   NaN  NaN  \n",
       "84      晟道集团～王平  1.343608e+10   晟道集团睢小光    9.0     7.2          NaN   NaN  NaN  \n",
       "\n",
       "[85 rows x 33 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "order_name_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# order_name_data.to_excel('./datas/order_name_clean.xlsx',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 读取用户信息 \n",
    "userPath = './datas/userInfo/user.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "userData = pd.read_excel(userPath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>用户微信名称</th>\n",
       "      <th>城市</th>\n",
       "      <th>姓名</th>\n",
       "      <th>手机号</th>\n",
       "      <th>酒店名称</th>\n",
       "      <th>地区</th>\n",
       "      <th>职位</th>\n",
       "      <th>地区名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>潘慧????（心零售）</td>\n",
       "      <td>内蒙古自治区 巴彦淖尔市 乌拉特前旗</td>\n",
       "      <td>潘磊</td>\n",
       "      <td>15598481777</td>\n",
       "      <td>皇嘉盛宴</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>黄勇军</td>\n",
       "      <td>湖北省 黄石市 黄石港区</td>\n",
       "      <td>黄勇军</td>\n",
       "      <td>18671400077</td>\n",
       "      <td>黄石金花大酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>蒙古丽宫杨晓凤</td>\n",
       "      <td>内蒙古自治区 锡林郭勒盟 锡林浩特市</td>\n",
       "      <td>杨晓凤</td>\n",
       "      <td>15647999744</td>\n",
       "      <td>蒙古丽宫酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>蓝天白云</td>\n",
       "      <td>广东省 广州市 增城区</td>\n",
       "      <td>黄淑清</td>\n",
       "      <td>13434287666</td>\n",
       "      <td>广州嘉力达酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>张波</td>\n",
       "      <td>四川省巴中市通江县</td>\n",
       "      <td>张波</td>\n",
       "      <td>13183522862</td>\n",
       "      <td>沁源春酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>孙毅.刀客15508138000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>孙毅</td>\n",
       "      <td>15508138000</td>\n",
       "      <td>时光美小蛙</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广东省 广州市 天河区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>A罗曼婚礼 李俊</td>\n",
       "      <td>NaN</td>\n",
       "      <td>冯晶</td>\n",
       "      <td>15179503646</td>\n",
       "      <td>壹家亲酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>江西省 宜春市 丰城市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>陇峰酒家-李伦</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李伦</td>\n",
       "      <td>18093293541</td>\n",
       "      <td>陇峰酒家</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>甘肃省 定西市 陇西县</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>茶者</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张建坤</td>\n",
       "      <td>15350558088</td>\n",
       "      <td>唐朝酒店</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>河北省 邢台市 宁晋县</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>『Darling 菲』。</td>\n",
       "      <td>NaN</td>\n",
       "      <td>任菲</td>\n",
       "      <td>13031408520</td>\n",
       "      <td>振头古镇</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>河北省 石家庄市 桥西区</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>741 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               用户微信名称                  城市   姓名          手机号     酒店名称   地区  \\\n",
       "0         潘慧????（心零售）  内蒙古自治区 巴彦淖尔市 乌拉特前旗   潘磊  15598481777     皇嘉盛宴  NaN   \n",
       "1                 黄勇军        湖北省 黄石市 黄石港区  黄勇军  18671400077  黄石金花大酒店  NaN   \n",
       "2             蒙古丽宫杨晓凤  内蒙古自治区 锡林郭勒盟 锡林浩特市  杨晓凤  15647999744   蒙古丽宫酒店  NaN   \n",
       "3                蓝天白云         广东省 广州市 增城区  黄淑清  13434287666  广州嘉力达酒店  NaN   \n",
       "4                  张波           四川省巴中市通江县   张波  13183522862    沁源春酒店  NaN   \n",
       "..                ...                 ...  ...          ...      ...  ...   \n",
       "736  孙毅.刀客15508138000                 NaN   孙毅  15508138000    时光美小蛙  NaN   \n",
       "737          A罗曼婚礼 李俊                 NaN   冯晶  15179503646    壹家亲酒店  NaN   \n",
       "738           陇峰酒家-李伦                 NaN   李伦  18093293541     陇峰酒家  NaN   \n",
       "739                茶者                 NaN  张建坤  15350558088     唐朝酒店  NaN   \n",
       "740      『Darling 菲』。                 NaN   任菲  13031408520     振头古镇  NaN   \n",
       "\n",
       "      职位          地区名称  \n",
       "0    NaN           NaN  \n",
       "1    NaN           NaN  \n",
       "2    NaN           NaN  \n",
       "3    NaN           NaN  \n",
       "4    NaN           NaN  \n",
       "..   ...           ...  \n",
       "736  NaN   广东省 广州市 天河区  \n",
       "737  NaN   江西省 宜春市 丰城市  \n",
       "738  NaN   甘肃省 定西市 陇西县  \n",
       "739  NaN   河北省 邢台市 宁晋县  \n",
       "740  NaN  河北省 石家庄市 桥西区  \n",
       "\n",
       "[741 rows x 8 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "userData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "order_name_data_copy = order_name_data.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                       远照\n",
       "1     李义--明珠大酒店18837776662\n",
       "2         李志伟¹⁵⁵ º³⁵⁸ ⁶ººº\n",
       "3                       渝夏\n",
       "4                   明天会更好!\n",
       "              ...         \n",
       "80                 齐乐^O^蓉蓉\n",
       "81                 遇见·美学策划\n",
       "82           特色猪棒骨，各种火锅，炒菜\n",
       "83                爱相随婚庆*庆典\n",
       "84            爱情果缘婚纱婚庆????\n",
       "Name: 买家, Length: 85, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "order_name_data_copy['买家']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 用户信息合并\n",
    "fData = pd.merge(order_name_data_copy,userData,left_on='买家',right_on='用户微信名称',how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>订单编号</th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>商品单价(单位为元)</th>\n",
       "      <th>商品数量</th>\n",
       "      <th>商品名称_x</th>\n",
       "      <th>订单类型</th>\n",
       "      <th>序号</th>\n",
       "      <th>...</th>\n",
       "      <th>真实姓名</th>\n",
       "      <th>大区</th>\n",
       "      <th>用户微信名称</th>\n",
       "      <th>城市</th>\n",
       "      <th>姓名</th>\n",
       "      <th>手机号</th>\n",
       "      <th>酒店名称</th>\n",
       "      <th>地区</th>\n",
       "      <th>职位</th>\n",
       "      <th>地区名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wkfC9TWJVcbcWNUSow2tu6Giwarv7y</td>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>杨选华</td>\n",
       "      <td>一区</td>\n",
       "      <td>远照</td>\n",
       "      <td>NaN</td>\n",
       "      <td>王远照</td>\n",
       "      <td>18699605578</td>\n",
       "      <td>群英荟萃酒店</td>\n",
       "      <td>新疆维吾尔自治区 巴音郭楞蒙古自治州 库尔勒市</td>\n",
       "      <td>总经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TGMUDQxdNWEoKLQZVoouf2YPbbVWlC</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李义</td>\n",
       "      <td>18837776662</td>\n",
       "      <td>明珠大酒店</td>\n",
       "      <td>河南省 南阳市 邓州市</td>\n",
       "      <td>总裁</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>15503586000</td>\n",
       "      <td>悦海楼</td>\n",
       "      <td>山西省 吕梁市 离石区</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>李庆</td>\n",
       "      <td>总部</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>NaN</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>13212370108</td>\n",
       "      <td>喜庄盛宴</td>\n",
       "      <td>重庆市 重庆市 长寿区</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐美</td>\n",
       "      <td>15924574160</td>\n",
       "      <td>杭锦旗康泰酒店有限责任公司</td>\n",
       "      <td>内蒙古自治区鄂尔多斯市杭锦旗</td>\n",
       "      <td>客房经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>iLjbmdPrZKUqXXiNB2McSG8g2UnzbY</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>72.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>师蓉蓉</td>\n",
       "      <td>13991019039</td>\n",
       "      <td>恒景温泉酒店</td>\n",
       "      <td>陕西省 咸阳市 三原县</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>uapXz6vHEdKfapAS5i3VZVht9AVEnx</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>73.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>刘程</td>\n",
       "      <td>13028443333</td>\n",
       "      <td>恒景酒店</td>\n",
       "      <td>陕西省 咸阳市 三原县</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>gPPms4rCQxc3LPhRRPZr5fiCoVISIx</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>74.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>齐佩茹</td>\n",
       "      <td>17736799722</td>\n",
       "      <td>醉骨大叔饭店</td>\n",
       "      <td>河北省 沧州市 黄骅市</td>\n",
       "      <td>老板</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>BPc4DknLec6SbSHvnUnKQFeM0ihZBa</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>贾国峰</td>\n",
       "      <td>13111773777</td>\n",
       "      <td>海景酒店</td>\n",
       "      <td>河北省 沧州市 黄骅市</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>唐明付</td>\n",
       "      <td>15823377968</td>\n",
       "      <td>爱情果缘婚礼策划</td>\n",
       "      <td>重庆市 重庆市 荣昌区</td>\n",
       "      <td>总经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              订单编号                    买家 买家真实姓名  合计费用(单位为元)  \\\n",
       "0   wkfC9TWJVcbcWNUSow2tu6Giwarv7y                    远照    王远照           1   \n",
       "1   TGMUDQxdNWEoKLQZVoouf2YPbbVWlC  李义--明珠大酒店18837776662    NaN           1   \n",
       "2   Bu82r2DxYGRGAnA2tKGKpAbBeYx0OD      李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟           1   \n",
       "3   p9oUSWRcwyzbnT7Z4jDpiNq1a98jRB                    渝夏     黄雨           1   \n",
       "4   nZ3FgtzuyeLKJDdeXFdFbK05X0t8nz                明天会更好!    NaN           1   \n",
       "..                             ...                   ...    ...         ...   \n",
       "80  iLjbmdPrZKUqXXiNB2McSG8g2UnzbY               齐乐^O^蓉蓉    NaN           1   \n",
       "81  uapXz6vHEdKfapAS5i3VZVht9AVEnx               遇见·美学策划    NaN           1   \n",
       "82  gPPms4rCQxc3LPhRRPZr5fiCoVISIx         特色猪棒骨，各种火锅，炒菜    NaN           1   \n",
       "83  BPc4DknLec6SbSHvnUnKQFeM0ihZBa              爱相随婚庆*庆典    NaN           1   \n",
       "84  xFDiEK6QCjBgKUHbYAKtJLS0XGdbMJ          爱情果缘婚纱婚庆????    NaN           1   \n",
       "\n",
       "   订单状态  商品单价(单位为元)  商品数量      商品名称_x  订单类型    序号  ... 真实姓名   大区  \\\n",
       "0   已完成           1     1  【万家灯火】爆破行动  普通订单   4.0  ...  杨选华   一区   \n",
       "1   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN  NaN   \n",
       "2   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN  NaN   \n",
       "3   已完成           1     1  【万家灯火】爆破行动  普通订单   6.0  ...   李庆   总部   \n",
       "4   已完成           1     1  【万家灯火】爆破行动  普通订单   NaN  ...  NaN  NaN   \n",
       "..  ...         ...   ...         ...   ...   ...  ...  ...  ...   \n",
       "80  已完成           1     1  【万家灯火】爆破行动  普通订单  72.0  ...  NaN  NaN   \n",
       "81  已完成           1     1  【万家灯火】爆破行动  普通订单  73.0  ...  NaN  NaN   \n",
       "82  已完成           1     1  【万家灯火】爆破行动  普通订单  74.0  ...  NaN  NaN   \n",
       "83  已完成           1     1  【万家灯火】爆破行动  普通订单  75.0  ...  NaN  NaN   \n",
       "84  已完成           1     1  【万家灯火】爆破行动  普通订单  77.0  ...  NaN  NaN   \n",
       "\n",
       "                  用户微信名称   城市   姓名          手机号           酒店名称  \\\n",
       "0                     远照  NaN  王远照  18699605578         群英荟萃酒店   \n",
       "1   李义--明珠大酒店18837776662  NaN   李义  18837776662          明珠大酒店   \n",
       "2       李志伟¹⁵⁵ º³⁵⁸ ⁶ººº  NaN  李志伟  15503586000            悦海楼   \n",
       "3                     渝夏  NaN   黄雨  13212370108           喜庄盛宴   \n",
       "4                 明天会更好!  NaN   徐美  15924574160  杭锦旗康泰酒店有限责任公司   \n",
       "..                   ...  ...  ...          ...            ...   \n",
       "80               齐乐^O^蓉蓉  NaN  师蓉蓉  13991019039         恒景温泉酒店   \n",
       "81               遇见·美学策划  NaN   刘程  13028443333           恒景酒店   \n",
       "82         特色猪棒骨，各种火锅，炒菜  NaN  齐佩茹  17736799722         醉骨大叔饭店   \n",
       "83              爱相随婚庆*庆典  NaN  贾国峰  13111773777           海景酒店   \n",
       "84          爱情果缘婚纱婚庆????  NaN  唐明付  15823377968       爱情果缘婚礼策划   \n",
       "\n",
       "                         地区    职位 地区名称  \n",
       "0   新疆维吾尔自治区 巴音郭楞蒙古自治州 库尔勒市   总经理  NaN  \n",
       "1               河南省 南阳市 邓州市    总裁  NaN  \n",
       "2               山西省 吕梁市 离石区    经理  NaN  \n",
       "3               重庆市 重庆市 长寿区    经理  NaN  \n",
       "4            内蒙古自治区鄂尔多斯市杭锦旗  客房经理  NaN  \n",
       "..                      ...   ...  ...  \n",
       "80              陕西省 咸阳市 三原县    经理  NaN  \n",
       "81              陕西省 咸阳市 三原县    经理  NaN  \n",
       "82              河北省 沧州市 黄骅市    老板  NaN  \n",
       "83              河北省 沧州市 黄骅市    经理  NaN  \n",
       "84              重庆市 重庆市 荣昌区   总经理  NaN  \n",
       "\n",
       "[85 rows x 41 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "fData.drop(['订单编号','商品名称_y','序号','交易时间_y','订单号','邀请方','推广员昵称_y'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>买家</th>\n",
       "      <th>买家真实姓名</th>\n",
       "      <th>合计费用(单位为元)</th>\n",
       "      <th>订单状态</th>\n",
       "      <th>商品单价(单位为元)</th>\n",
       "      <th>商品数量</th>\n",
       "      <th>商品名称_x</th>\n",
       "      <th>订单类型</th>\n",
       "      <th>完成时间</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>...</th>\n",
       "      <th>真实姓名</th>\n",
       "      <th>大区</th>\n",
       "      <th>用户微信名称</th>\n",
       "      <th>城市</th>\n",
       "      <th>姓名</th>\n",
       "      <th>手机号</th>\n",
       "      <th>酒店名称</th>\n",
       "      <th>地区</th>\n",
       "      <th>职位</th>\n",
       "      <th>地区名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>远照</td>\n",
       "      <td>王远照</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 14:47:08</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>杨选华</td>\n",
       "      <td>一区</td>\n",
       "      <td>远照</td>\n",
       "      <td>NaN</td>\n",
       "      <td>王远照</td>\n",
       "      <td>18699605578</td>\n",
       "      <td>群英荟萃酒店</td>\n",
       "      <td>新疆维吾尔自治区 巴音郭楞蒙古自治州 库尔勒市</td>\n",
       "      <td>总经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李义--明珠大酒店18837776662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李义</td>\n",
       "      <td>18837776662</td>\n",
       "      <td>明珠大酒店</td>\n",
       "      <td>河南省 南阳市 邓州市</td>\n",
       "      <td>总裁</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李志伟¹⁵⁵ º³⁵⁸ ⁶ººº</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李志伟</td>\n",
       "      <td>15503586000</td>\n",
       "      <td>悦海楼</td>\n",
       "      <td>山西省 吕梁市 离石区</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>渝夏</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 14:45:19</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>李庆</td>\n",
       "      <td>总部</td>\n",
       "      <td>渝夏</td>\n",
       "      <td>NaN</td>\n",
       "      <td>黄雨</td>\n",
       "      <td>13212370108</td>\n",
       "      <td>喜庄盛宴</td>\n",
       "      <td>重庆市 重庆市 长寿区</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>明天会更好!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐美</td>\n",
       "      <td>15924574160</td>\n",
       "      <td>杭锦旗康泰酒店有限责任公司</td>\n",
       "      <td>内蒙古自治区鄂尔多斯市杭锦旗</td>\n",
       "      <td>客房经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 10:23:31</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>齐乐^O^蓉蓉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>师蓉蓉</td>\n",
       "      <td>13991019039</td>\n",
       "      <td>恒景温泉酒店</td>\n",
       "      <td>陕西省 咸阳市 三原县</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 10:11:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>遇见·美学策划</td>\n",
       "      <td>NaN</td>\n",
       "      <td>刘程</td>\n",
       "      <td>13028443333</td>\n",
       "      <td>恒景酒店</td>\n",
       "      <td>陕西省 咸阳市 三原县</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 09:21:04</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>特色猪棒骨，各种火锅，炒菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>齐佩茹</td>\n",
       "      <td>17736799722</td>\n",
       "      <td>醉骨大叔饭店</td>\n",
       "      <td>河北省 沧州市 黄骅市</td>\n",
       "      <td>老板</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-30 09:09:02</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>爱相随婚庆*庆典</td>\n",
       "      <td>NaN</td>\n",
       "      <td>贾国峰</td>\n",
       "      <td>13111773777</td>\n",
       "      <td>海景酒店</td>\n",
       "      <td>河北省 沧州市 黄骅市</td>\n",
       "      <td>经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>已完成</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>【万家灯火】爆破行动</td>\n",
       "      <td>普通订单</td>\n",
       "      <td>2020-04-29 19:07:35</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>爱情果缘婚纱婚庆????</td>\n",
       "      <td>NaN</td>\n",
       "      <td>唐明付</td>\n",
       "      <td>15823377968</td>\n",
       "      <td>爱情果缘婚礼策划</td>\n",
       "      <td>重庆市 重庆市 荣昌区</td>\n",
       "      <td>总经理</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      买家 买家真实姓名  合计费用(单位为元) 订单状态  商品单价(单位为元)  商品数量  \\\n",
       "0                     远照    王远照           1  已完成           1     1   \n",
       "1   李义--明珠大酒店18837776662    NaN           1  已完成           1     1   \n",
       "2       李志伟¹⁵⁵ º³⁵⁸ ⁶ººº    李志伟           1  已完成           1     1   \n",
       "3                     渝夏     黄雨           1  已完成           1     1   \n",
       "4                 明天会更好!    NaN           1  已完成           1     1   \n",
       "..                   ...    ...         ...  ...         ...   ...   \n",
       "80               齐乐^O^蓉蓉    NaN           1  已完成           1     1   \n",
       "81               遇见·美学策划    NaN           1  已完成           1     1   \n",
       "82         特色猪棒骨，各种火锅，炒菜    NaN           1  已完成           1     1   \n",
       "83              爱相随婚庆*庆典    NaN           1  已完成           1     1   \n",
       "84          爱情果缘婚纱婚庆????    NaN           1  已完成           1     1   \n",
       "\n",
       "        商品名称_x  订单类型                 完成时间  成交金额  ... 真实姓名   大区  \\\n",
       "0   【万家灯火】爆破行动  普通订单  2020-04-30 14:47:08   1.0  ...  杨选华   一区   \n",
       "1   【万家灯火】爆破行动  普通订单                  NaN   NaN  ...  NaN  NaN   \n",
       "2   【万家灯火】爆破行动  普通订单                  NaN   NaN  ...  NaN  NaN   \n",
       "3   【万家灯火】爆破行动  普通订单  2020-04-30 14:45:19   1.0  ...   李庆   总部   \n",
       "4   【万家灯火】爆破行动  普通订单                  NaN   NaN  ...  NaN  NaN   \n",
       "..         ...   ...                  ...   ...  ...  ...  ...   \n",
       "80  【万家灯火】爆破行动  普通订单  2020-04-30 10:23:31   1.0  ...  NaN  NaN   \n",
       "81  【万家灯火】爆破行动  普通订单  2020-04-30 10:11:20   1.0  ...  NaN  NaN   \n",
       "82  【万家灯火】爆破行动  普通订单  2020-04-30 09:21:04   1.0  ...  NaN  NaN   \n",
       "83  【万家灯火】爆破行动  普通订单  2020-04-30 09:09:02   1.0  ...  NaN  NaN   \n",
       "84  【万家灯火】爆破行动  普通订单  2020-04-29 19:07:35   1.0  ...  NaN  NaN   \n",
       "\n",
       "                  用户微信名称   城市   姓名          手机号           酒店名称  \\\n",
       "0                     远照  NaN  王远照  18699605578         群英荟萃酒店   \n",
       "1   李义--明珠大酒店18837776662  NaN   李义  18837776662          明珠大酒店   \n",
       "2       李志伟¹⁵⁵ º³⁵⁸ ⁶ººº  NaN  李志伟  15503586000            悦海楼   \n",
       "3                     渝夏  NaN   黄雨  13212370108           喜庄盛宴   \n",
       "4                 明天会更好!  NaN   徐美  15924574160  杭锦旗康泰酒店有限责任公司   \n",
       "..                   ...  ...  ...          ...            ...   \n",
       "80               齐乐^O^蓉蓉  NaN  师蓉蓉  13991019039         恒景温泉酒店   \n",
       "81               遇见·美学策划  NaN   刘程  13028443333           恒景酒店   \n",
       "82         特色猪棒骨，各种火锅，炒菜  NaN  齐佩茹  17736799722         醉骨大叔饭店   \n",
       "83              爱相随婚庆*庆典  NaN  贾国峰  13111773777           海景酒店   \n",
       "84          爱情果缘婚纱婚庆????  NaN  唐明付  15823377968       爱情果缘婚礼策划   \n",
       "\n",
       "                         地区    职位 地区名称  \n",
       "0   新疆维吾尔自治区 巴音郭楞蒙古自治州 库尔勒市   总经理  NaN  \n",
       "1               河南省 南阳市 邓州市    总裁  NaN  \n",
       "2               山西省 吕梁市 离石区    经理  NaN  \n",
       "3               重庆市 重庆市 长寿区    经理  NaN  \n",
       "4            内蒙古自治区鄂尔多斯市杭锦旗  客房经理  NaN  \n",
       "..                      ...   ...  ...  \n",
       "80              陕西省 咸阳市 三原县    经理  NaN  \n",
       "81              陕西省 咸阳市 三原县    经理  NaN  \n",
       "82              河北省 沧州市 黄骅市    老板  NaN  \n",
       "83              河北省 沧州市 黄骅市    经理  NaN  \n",
       "84              重庆市 重庆市 荣昌区   总经理  NaN  \n",
       "\n",
       "[85 rows x 34 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "fData.to_excel('./datas/fData_clean0430.xlsx',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
